/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 80100
 Source Host           : localhost:3316
 Source Schema         : wos

 Target Server Type    : MySQL
 Target Server Version : 80100
 File Encoding         : 65001

 Date: 17/01/2024 03:08:08
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `deptId` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
  `parentId` bigint DEFAULT '0' COMMENT '父部门id',
  `ancestors` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '祖级列表',
  `deptName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '部门名称',
  `orderNum` int DEFAULT '0' COMMENT '显示顺序',
  `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '负责人',
  `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '邮箱',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '部门状态（0正常 1停用）',
  `delFlag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `version` int DEFAULT '0' COMMENT '热更',
  PRIMARY KEY (`deptId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=208 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`deptId`, `parentId`, `ancestors`, `deptName`, `orderNum`, `leader`, `phone`, `email`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `version`) VALUES (100, 0, '0', '长新动力', 0, '子汇', '19000000000', 'cx@qq.com', '0', '0', 'admin', '2023-11-16 04:00:04', 'admin', '2023-11-25 03:53:26', 1705431300);
INSERT INTO `sys_dept` (`deptId`, `parentId`, `ancestors`, `deptName`, `orderNum`, `leader`, `phone`, `email`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `version`) VALUES (102, 100, '0,100', '北京分公司', 2, '长新', '19000000000', 'cx@qq.com', '0', '0', 'admin', '2023-11-16 04:00:04', 'admin', '2024-01-16 18:51:52', 1705431297);
INSERT INTO `sys_dept` (`deptId`, `parentId`, `ancestors`, `deptName`, `orderNum`, `leader`, `phone`, `email`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `version`) VALUES (103, 101, '0,100,101', '研发部门', 1, '长新', '19000000000', 'cx@qq.com', '0', '0', 'admin', '2023-11-16 04:00:04', '', NULL, 1705431295);
INSERT INTO `sys_dept` (`deptId`, `parentId`, `ancestors`, `deptName`, `orderNum`, `leader`, `phone`, `email`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `version`) VALUES (205, 100, '0,100', '长春总公司', 0, '长新', '19000000000', 'cx@qq.com', '0', '0', 'admin', '2023-11-25 03:52:31', 'admin', '2024-01-06 10:26:44', 1705431292);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `dictCode` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dictSort` int DEFAULT '0' COMMENT '字典排序',
  `dictLabel` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典标签',
  `dictValue` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典键值',
  `dictType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典类型',
  `cssClass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '样式属性（其他样式扩展）',
  `listClass` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '表格回显样式',
  `isDefault` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'N' COMMENT '是否默认（Y是 N否）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `version` int DEFAULT '0' COMMENT '热更',
  PRIMARY KEY (`dictCode`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典数据表';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2023-11-16 04:00:05', 'admin', '2023-12-16 07:17:33', '性别男1', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2, 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '性别女', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (3, 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2023-11-16 04:00:05', 'admin', '2024-01-06 09:55:14', '性别未知', 1704534915);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (4, 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '显示菜单', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (5, 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '隐藏菜单', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (6, 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '正常状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (7, 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', 'admin', '2024-01-04 21:23:46', '停用状态', 1704403426);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (8, 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '正常状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (9, 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '停用状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (10, 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '默认分组', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (11, 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '系统分组', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (12, 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '系统默认是', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (13, 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '系统默认否', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (14, 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '通知', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (15, 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '公告', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (16, 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '正常状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (17, 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '关闭状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (18, 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '其他操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (19, 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '新增操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (20, 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '修改操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (21, 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '删除操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (22, 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '授权操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (23, 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '导出操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (24, 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '导入操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (25, 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '强退操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (26, 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '生成操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (27, 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '清空操作', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (28, 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '正常状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (29, 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '停用状态', 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (100, 0, '目录', 'M', 'sys_menu_type', NULL, 'primary', 'N', '0', 'admin', '2023-11-18 09:11:00', 'admin', '2023-11-18 09:31:20', NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (101, 0, '菜单', 'C', 'sys_menu_type', NULL, 'success', 'N', '0', 'admin', '2023-11-18 09:11:47', 'admin', '2023-11-18 09:31:29', NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (102, 0, '按钮', 'F', 'sys_menu_type', NULL, 'info', 'N', '0', 'admin', '2023-11-18 09:12:12', 'admin', '2023-11-18 09:31:35', NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (103, 1, '默认(default)', 'default', 'sys_list_class', 'default', 'default', 'N', '0', 'admin', '2023-12-16 08:32:57', '', NULL, NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (104, 2, '主要(primary)', 'primary', 'sys_list_class', 'primary', 'primary', 'N', '0', 'admin', '2023-12-16 08:33:18', '', NULL, NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (105, 3, '成功(success)', 'success', 'sys_list_class', 'success', 'success', 'N', '0', 'admin', '2023-12-16 08:34:05', 'admin', '2023-12-16 08:34:34', NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (106, 4, '信息(info)', 'info', 'sys_list_class', 'info', 'info', 'N', '0', 'admin', '2023-12-16 08:34:25', '', NULL, NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (107, 5, '警告(warning)', 'warning', 'sys_list_class', 'warning', 'warning', 'N', '0', 'admin', '2023-12-16 08:34:52', '', NULL, NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (108, 6, '危险(danger)', 'danger', 'sys_list_class', 'danger', 'danger', 'N', '0', 'admin', '2023-12-16 08:35:11', '', NULL, NULL, 0);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (113, 1, '成功', 'false', 'sys_request_type', 'null', 'success', 'N', '0', 'admin', '2023-12-20 03:33:45', 'admin', '2024-01-11 04:25:32', 'null', 1704947132);
INSERT INTO `sys_dict_data` (`dictCode`, `dictSort`, `dictLabel`, `dictValue`, `dictType`, `cssClass`, `listClass`, `isDefault`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (114, 1, '失败', 'true', 'sys_request_type', 'null', 'warning', 'N', '0', 'admin', '2023-12-20 03:33:56', 'admin', '2024-01-11 04:25:37', 'null', 1704947137);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `dictId` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dictName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典名称',
  `dictType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `version` int DEFAULT '0',
  PRIMARY KEY (`dictId`) USING BTREE,
  UNIQUE KEY `dictType` (`dictType`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='字典类型表';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (1, '用户性别', 'sys_user_sex', '0', 'admin', '2023-11-16 04:00:05', 'admin', '2024-01-06 04:45:36', '用户性别列表1', 1704516336);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2, '菜单状态', 'sys_show_hide', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '菜单状态列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (3, '系统开关', 'sys_normal_disable', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '系统开关列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (4, '任务状态', 'sys_job_status', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '任务状态列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (5, '任务分组', 'sys_job_group', '0', 'admin', '2023-11-16 04:00:05', 'admin', '2024-01-04 20:00:17', '任务分组列表', 1704398417);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (6, '系统是否', 'sys_yes_no', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '系统是否列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (7, '通知类型', 'sys_notice_type', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '通知类型列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (8, '通知状态', 'sys_notice_status', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '通知状态列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (9, '操作类型', 'sys_oper_type', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '操作类型列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (10, '系统状态', 'sys_common_status', '0', 'admin', '2023-11-16 04:00:05', '', NULL, '登录状态列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (100, '菜单资源类型', 'sys_menu_type', '0', 'admin', '2023-11-18 09:10:18', '', NULL, '菜单资源的类型', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (101, '字典值测试', 'test_dicts_1', '0', 'admin', '2023-12-16 03:26:22', '', NULL, NULL, 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (105, '默认样式', 'sys_list_class', '0', 'admin', '2023-12-16 08:26:49', 'admin', '2023-12-16 08:38:45', NULL, 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (107, '请求状态', 'sys_request_type', '0', 'admin', '2023-12-20 03:32:46', '', NULL, '日志中请求', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (110, 'temp', 'sys_job_group11', '0', '', NULL, '', NULL, '任务分组列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (116, 'temp', 'sys_job_group222', '0', '', NULL, '', NULL, '任务分组列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (117, 'temp', 'sys_job_group333', '0', 'admin', '2024-01-04 19:36:58', '', NULL, '任务分组列表', 0);
INSERT INTO `sys_dict_type` (`dictId`, `dictName`, `dictType`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (122, 'test', 'test', '1', 'admin', '2024-01-06 04:48:38', '', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_log_login
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_login`;
CREATE TABLE `sys_log_login` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
  `ip` varchar(100) COLLATE utf8mb4_bin DEFAULT NULL,
  `userAgent` text COLLATE utf8mb4_bin,
  `status` char(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '0 未成功 1 成功',
  `createTime` datetime DEFAULT CURRENT_TIMESTAMP,
  `msg` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登陆的错误',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of sys_log_login
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_log_system
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_system`;
CREATE TABLE `sys_log_system` (
  `id` int NOT NULL AUTO_INCREMENT,
  `creatDatetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '访问时间',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '访问地址',
  `postQuery` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT 'POST请求',
  `getQuery` text COLLATE utf8mb4_bin COMMENT 'GET请求',
  `title` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '日志类型',
  `method` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '方法',
  `userIp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户地址',
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'TOKEN',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用户名',
  `userAgent` text COLLATE utf8mb4_bin COMMENT '用户浏览器类型',
  `code` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '返回代码',
  `msg` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '返回的数据提示信息',
  `runTime` int DEFAULT NULL COMMENT '运行时间，单位毫秒',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2874 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统日志表';

-- ----------------------------
-- Records of sys_log_system
-- ----------------------------
BEGIN;
INSERT INTO `sys_log_system` (`id`, `creatDatetime`, `url`, `postQuery`, `getQuery`, `title`, `method`, `userIp`, `token`, `username`, `userAgent`, `code`, `msg`, `runTime`) VALUES (2872, '2024-01-17 03:07:48', '/api/system/operlog/clean', '{}', '{}', '日志', 'DELETE', '::ffff:127.0.0.1', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjoiYWRtaW4iLCJleHAiOjE3MDU0NTczNDgwMTksImlhdCI6MTcwNTQyODU0OH0.oi89bDCIouGGQNspSjTh-mUln2rzcYng8XDXndN_QT0', 'admin', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', '200', 'success', 50);
INSERT INTO `sys_log_system` (`id`, `creatDatetime`, `url`, `postQuery`, `getQuery`, `title`, `method`, `userIp`, `token`, `username`, `userAgent`, `code`, `msg`, `runTime`) VALUES (2873, '2024-01-17 03:07:48', '/api/system/operlog/list?pageNum=1&pageSize=10', '{}', '{\"pageNum\":\"1\",\"pageSize\":\"10\"}', '日志', 'GET', '::ffff:127.0.0.1', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjoiYWRtaW4iLCJleHAiOjE3MDU0NTczNDgwMTksImlhdCI6MTcwNTQyODU0OH0.oi89bDCIouGGQNspSjTh-mUln2rzcYng8XDXndN_QT0', 'admin', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36', '200', 'success', 167);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `menuId` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
  `menuName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '菜单名称',
  `parentId` bigint DEFAULT '0' COMMENT '父菜单ID',
  `orderNum` int DEFAULT '0' COMMENT '显示顺序',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '组件路径',
  `query` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '路由参数',
  `isFrame` int DEFAULT '1' COMMENT '是否为外链（0是 1否）',
  `isCache` int DEFAULT '0' COMMENT '是否缓存（0缓存 1不缓存）',
  `menuType` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '菜单状态（0正常 1停用）',
  `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '#' COMMENT '菜单图标',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '备注',
  `version` int DEFAULT '0',
  PRIMARY KEY (`menuId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2073 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2000, '系统设置', 0, 10, 'home/system', NULL, NULL, 1, 0, 'M', '0', '0', '', '#', 'admin', '2023-11-16 06:33:18', 'admin', '2023-12-20 01:17:19', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2001, '菜单与资源', 2000, 6, '/home/system/menu', '/src/pages/home/system/menu/index.vue', 'null', 1, 1, 'C', '0', '0', 'system:menu:list', '#', 'admin', '2023-11-16 06:35:31', 'admin', '2024-01-07 21:20:11', '', 1704662411);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2014, '部门管理', 2000, 3, '/home/system/dept', '/src/pages/home/system/dept/index.vue', NULL, 1, 0, 'C', '0', '0', 'system:dept:list', '#', 'admin', '2023-11-25 03:19:16', 'root', '2023-12-27 03:05:36', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2015, '岗位管理', 2000, 4, '/home/system/post', '/src/pages/home/system/post/index.vue', NULL, 1, 0, 'C', '0', '0', 'system:post:list', '#', 'admin', '2023-11-27 00:34:21', 'root', '2023-12-27 03:00:14', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2016, '角色管理', 2000, 2, '/home/system/role', '/src/pages/home/system/role/index.vue', NULL, 1, 0, 'C', '0', '0', 'system:role:list', '#', 'admin', '2023-11-27 04:16:20', 'root', '2023-12-27 03:10:10', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2017, '字典管理', 2000, 5, '/home/system/dict', '/src/pages/home/system/dict/index.vue', NULL, 1, 0, 'C', '0', '0', 'system:dict:list', '#', 'admin', '2023-12-16 02:54:07', 'root', '2023-12-27 02:48:12', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2018, '字典值', 2000, 1, '/home/system/keyword', '/src/pages/home/system/keyword/index.vue', NULL, 1, 0, 'C', '1', '0', 'system_dict_keyword', '#', 'admin', '2023-12-16 03:41:12', 'admin', '2023-12-16 05:25:02', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2019, '用户管理', 2000, 1, '/home/system/user', '/src/pages/home/system/user/index.vue', NULL, 1, 0, 'C', '0', '0', 'system:user:list', '#', 'admin', '2023-12-17 07:10:42', 'root', '2023-12-27 03:13:40', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2020, '日志管理', 0, 20, 'home/log', NULL, NULL, 1, 0, 'M', '0', '0', '', '#', 'admin', '2023-12-20 01:16:56', 'admin', '2023-12-20 02:41:32', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2021, '登陆日志', 2020, 1, '/home/log/login', '/src/pages/home/log/login/index.vue', NULL, 1, 1, 'C', '0', '0', 'monitor:logininfor:list', '#', 'admin', '2023-12-20 02:38:46', 'root', '2023-12-27 03:18:17', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2022, '系统日志', 2020, 20, '/home/log/system', '/src/pages/home/log/system/index.vue', NULL, 1, 1, 'C', '0', '0', 'monitor:operlog:list', '#', 'admin', '2023-12-20 05:12:45', 'root', '2023-12-27 03:17:54', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2023, '系统监控', 0, 30, 'home/monitor', NULL, NULL, 1, 0, 'M', '0', '0', '', '#', 'admin', '2023-12-24 01:57:02', 'admin', '2023-12-24 02:04:35', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2024, '在线用户', 2023, 1, '/home/monitor/online', '/src/pages/home/monitor/online/index.vue', NULL, 1, 0, 'C', '0', '0', 'monitor:online:list', '#', 'admin', '2023-12-24 02:11:11', 'root', '2023-12-27 03:21:50', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2025, '服务器状态', 2023, 2, '/home/monitor/server', '/src/pages/home/monitor/server/index.vue', NULL, 1, 0, 'C', '0', '0', 'monitor:server:list', '#', 'admin', '2023-12-24 02:49:06', 'root', '2023-12-27 03:23:32', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2026, '新增', 2001, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:menu:add', '#', 'admin', '2023-12-25 01:18:58', 'admin', '2023-12-27 02:22:50', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2027, '修改', 2001, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:menu:edit', '#', 'admin', '2023-12-25 01:19:28', 'admin', '2023-12-27 02:23:04', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2028, '删除', 2001, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:menu:remove', '#', 'admin', '2023-12-25 01:21:30', 'admin', '2023-12-27 02:23:16', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2035, '查询', 2001, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:menu:query', '#', 'admin', '2023-12-27 02:23:33', 'admin', '2023-12-27 02:23:46', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2037, '字典查询', 2017, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dict:query', '#', 'root', '2023-12-27 02:48:51', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2038, '字典新增', 2017, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dict:add', '#', 'root', '2023-12-27 02:49:44', 'admin', '2023-12-27 02:51:00', '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2039, '字典修改', 2017, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dict:edit', '#', 'root', '2023-12-27 02:50:03', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2040, '字典删除', 2017, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dict:remove', '#', 'root', '2023-12-27 02:50:18', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2041, '字典导出', 2017, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dict:export', '#', 'root', '2023-12-27 02:50:36', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2042, '岗位查询', 2015, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:post:query', '#', 'root', '2023-12-27 03:00:53', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2043, '岗位新增', 2015, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:post:add', '#', 'root', '2023-12-27 03:01:12', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2044, '岗位修改', 2015, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:post:edit', '#', 'root', '2023-12-27 03:01:28', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2045, '岗位删除', 2015, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:post:remove', '#', 'root', '2023-12-27 03:01:44', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2046, '岗位导出', 2015, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:post:export', '#', 'root', '2023-12-27 03:02:04', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2047, '部门查询', 2014, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:query', '#', 'root', '2023-12-27 03:06:05', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2048, '部门新增', 2014, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:add', '#', 'root', '2023-12-27 03:06:22', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2049, '部门修改', 2014, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:edit', '#', 'root', '2023-12-27 03:06:39', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2050, '部门删除', 2014, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:dept:remove', '#', 'root', '2023-12-27 03:06:56', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2051, '角色查询', 2016, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:role:query', '#', 'root', '2023-12-27 03:10:29', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2052, '角色新增', 2016, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:role:add', '#', 'root', '2023-12-27 03:10:45', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2053, '角色修改', 2016, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:role:edit', '#', 'root', '2023-12-27 03:11:01', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2054, '角色删除', 2016, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:role:remove', '#', 'root', '2023-12-27 03:11:16', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2055, '角色导出', 2016, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:role:export', '#', 'root', '2023-12-27 03:11:32', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2056, '用户查询', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:query', '#', 'root', '2023-12-27 03:14:00', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2057, '用户新增', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:add', '#', 'root', '2023-12-27 03:14:19', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2058, '用户修改', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:edit', '#', 'root', '2023-12-27 03:14:34', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2059, '用户删除', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:remove', '#', 'root', '2023-12-27 03:14:50', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2060, '用户导出', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:export', '#', 'root', '2023-12-27 03:15:07', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2061, '用户导入', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:import', '#', 'root', '2023-12-27 03:15:23', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2062, '重置密码', 2019, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'system:user:resetPwd', '#', 'root', '2023-12-27 03:15:38', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2063, '登录查询', 2021, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:logininfor:query', '#', 'root', '2023-12-27 03:19:19', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2064, '登录删除', 2022, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:logininfor:remove', '#', 'root', '2023-12-27 03:19:36', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2065, '日志导出', 2022, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:logininfor:export', '#', 'root', '2023-12-27 03:19:52', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2066, '账户解锁', 2022, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:logininfor:unlock', '#', 'root', '2023-12-27 03:20:10', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2067, '操作查询', 2022, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:operlog:query', '#', 'root', '2023-12-27 03:20:43', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2068, '操作删除', 2021, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:operlog:remove', '#', 'root', '2023-12-27 03:21:00', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2069, '日志导出', 2021, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:operlog:export', '#', 'root', '2023-12-27 03:21:16', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2070, '在线查询', 2024, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:online:query', '#', 'root', '2023-12-27 03:22:08', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2071, '批量强退', 2024, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:online:batchLogout', '#', 'root', '2023-12-27 03:22:28', '', NULL, '', 0);
INSERT INTO `sys_menu` (`menuId`, `menuName`, `parentId`, `orderNum`, `path`, `component`, `query`, `isFrame`, `isCache`, `menuType`, `visible`, `status`, `perms`, `icon`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2072, '单条强退', 2024, 1, '', NULL, NULL, 1, 0, 'F', '0', '0', 'monitor:online:forceLogout', '#', 'root', '2023-12-27 03:22:42', '', NULL, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `postId` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
  `postCode` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '岗位编码',
  `postName` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '岗位名称',
  `postSort` int NOT NULL COMMENT '显示顺序',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '状态（0正常 1停用）',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `version` int DEFAULT '0',
  PRIMARY KEY (`postId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='岗位信息表';

-- ----------------------------
-- Records of sys_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_post` (`postId`, `postCode`, `postName`, `postSort`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (1, 'ceo', '董事长', 1, '0', 'admin', '2023-11-16 04:00:04', '', NULL, '', 0);
INSERT INTO `sys_post` (`postId`, `postCode`, `postName`, `postSort`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2, 'se', '项目经理', 2, '0', 'admin', '2023-11-16 04:00:04', 'admin', '2024-01-06 10:05:45', '', 1704535546);
INSERT INTO `sys_post` (`postId`, `postCode`, `postName`, `postSort`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (3, 'hr', '人力资源', 3, '0', 'admin', '2023-11-16 04:00:04', '', NULL, '', 0);
INSERT INTO `sys_post` (`postId`, `postCode`, `postName`, `postSort`, `status`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (4, 'user', '普通员工', 4, '0', 'admin', '2023-11-16 04:00:04', '', NULL, '', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `roleId` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `roleName` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '角色名称',
  `roleKey` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '角色权限字符串',
  `roleSort` int NOT NULL DEFAULT '0' COMMENT '显示顺序',
  `dataScope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
  `menuCheckStrictly` tinyint(1) DEFAULT '1' COMMENT '菜单树选择项是否关联显示',
  `deptCheckStrictly` tinyint(1) DEFAULT '1' COMMENT '部门树选择项是否关联显示',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0' COMMENT '角色状态（0正常 1停用）',
  `delFlag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `createBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '创建者',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `updateBy` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '更新者',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '备注',
  `version` int DEFAULT '0',
  PRIMARY KEY (`roleId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=115 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色信息表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`roleId`, `roleName`, `roleKey`, `roleSort`, `dataScope`, `menuCheckStrictly`, `deptCheckStrictly`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (1, '超级管理员', 'admin', 1, '1', 1, 1, '0', '0', 'admin', '2023-11-16 04:00:04', '', NULL, '超级管理员', 0);
INSERT INTO `sys_role` (`roleId`, `roleName`, `roleKey`, `roleSort`, `dataScope`, `menuCheckStrictly`, `deptCheckStrictly`, `status`, `delFlag`, `createBy`, `createTime`, `updateBy`, `updateTime`, `remark`, `version`) VALUES (2, '普通角色', 'common', 2, '2', 1, 1, '0', '0', 'admin', '2023-11-16 04:00:04', 'admin', '2024-01-15 03:40:49', '普通角色', 1705290049);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_dept`;
CREATE TABLE `sys_role_dept` (
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `dept_id` bigint NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`role_id`,`dept_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和部门关联表';

-- ----------------------------
-- Records of sys_role_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 100);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 101);
INSERT INTO `sys_role_dept` (`role_id`, `dept_id`) VALUES (2, 105);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `roleId` bigint NOT NULL COMMENT '角色ID',
  `menuId` bigint NOT NULL COMMENT '菜单ID',
  PRIMARY KEY (`roleId`,`menuId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='角色和菜单关联表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (2, 2025);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (2, 2070);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (2, 2071);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (2, 2072);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2063);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2064);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2065);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2066);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2067);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2068);
INSERT INTO `sys_role_menu` (`roleId`, `menuId`) VALUES (114, 2069);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `userId` int NOT NULL AUTO_INCREMENT,
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '密码',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0' COMMENT '用户类型',
  `nickName` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '昵称',
  `phonenumber` varchar(30) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '手机号码',
  `email` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '电子邮件',
  `sex` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '性别',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '头像',
  `delFlag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '1' COMMENT '删除标志（1代表存在0代表删除）',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '备注',
  `lastLoginTime` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次登陆时间',
  `lastLoginIp` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '最后一次登陆IP',
  `permissions` text COLLATE utf8mb4_bin COMMENT '登录后暂存信息',
  `roles` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录后暂存信息',
  `token` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '登录后的token',
  `deptId` int DEFAULT NULL COMMENT '部门id',
  `status` char(1) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '状态',
  `updateBy` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `createTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `createBy` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  PRIMARY KEY (`userId`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`userId`, `username`, `password`, `type`, `nickName`, `phonenumber`, `email`, `sex`, `avatar`, `delFlag`, `remark`, `lastLoginTime`, `lastLoginIp`, `permissions`, `roles`, `token`, `deptId`, `status`, `updateBy`, `updateTime`, `createTime`, `createBy`) VALUES (1, 'admin', '7fef6171469e80d32c0559f88b377245', '1', 'WOS', '13088889999', 'wos-server@ccems.com', '1', 'null', '1', 'null', '2024-01-17 02:09:08', '::ffff:127.0.0.1', '*:*:*', '', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJkYXRhIjoiYWRtaW4iLCJleHAiOjE3MDU0NTczNDgwMTksImlhdCI6MTcwNTQyODU0OH0.oi89bDCIouGGQNspSjTh-mUln2rzcYng8XDXndN_QT0', 100, '0', 'admin', '2024-01-15 03:00:22', '2024-01-03 12:19:21', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_post
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `userId` bigint NOT NULL COMMENT '用户ID',
  `postId` bigint NOT NULL COMMENT '岗位ID',
  PRIMARY KEY (`userId`,`postId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户与岗位关联表';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (2, 1);
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (2, 2);
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (2, 3);
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (3, 1);
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (3, 2);
INSERT INTO `sys_user_post` (`userId`, `postId`) VALUES (4, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `userId` bigint NOT NULL COMMENT '用户ID',
  `roleId` bigint NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`userId`,`roleId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='用户和角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Triggers structure for table sys_dept
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_dept_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_dept_version` BEFORE UPDATE ON `sys_dept` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();  
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table sys_dict_data
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_dict_data_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_dict_data_version` BEFORE UPDATE ON `sys_dict_data` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();  
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table sys_dict_type
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_dict_type_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_dict_type_version` BEFORE UPDATE ON `sys_dict_type` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table sys_menu
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_menu_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_menu_version` BEFORE UPDATE ON `sys_menu` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();  
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table sys_post
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_post_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_post_version` BEFORE UPDATE ON `sys_post` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();  
END
;;
delimiter ;

-- ----------------------------
-- Triggers structure for table sys_role
-- ----------------------------
DROP TRIGGER IF EXISTS `wos_sys_role_version`;
delimiter ;;
CREATE TRIGGER `wos_sys_role_version` BEFORE UPDATE ON `sys_role` FOR EACH ROW BEGIN  
    SET NEW.version = UNIX_TIMESTAMP();  
END
;;
delimiter ;

SET FOREIGN_KEY_CHECKS = 1;
